Integrating AssetWise with Microsoft® SQL Server® Reporting Services
- Microsoft SQL Server 2016
Reporting Services (SSRS) and SQL Server Data Tools 16.5 (SSDT) for Visual
Studio 2015 are already installed
or
- Microsoft SQL Server 2019 Reporting Services (SSRS), Visual Studio 2019, and Microsoft Reporting Services Projects extension for Visual Studio 2019 are already installed
AssetWise SSRS Data Provider is used to create SSRS reports using data from your AssetWise community.
SQL Server Reporting Services (server) and SQL Server Data Tools (client) can be installed on the same or separate computers. AssetWise SSRS Data Provider must be installed on both computers, if SQL Server Reporting Services and SQL Server Data Tools are installed on different computers.
Tip: The
AssetWise SSRS Data Provider installer assumes
your SQL Server 2016 installation has the default instance name
MSSQLSERVER. If this is not the name of your instance,
the installer will inform you that the required product is not installed. As a
workaround, you can run the installer from the command line to specify the
correct instance name:
msiexec /I "optional\path\to\AssetWise ALIM SSRS (x64).msi" EB_REPORTINGSERVICES_INSTANCENAME=MyInstanceName